2 replies to this topic

[vijijs]

I am able to create the DSN using the ODBC Resources but my requirement is that needs to be created dynamically since the customer can provide/maintain the DSN in any name.

So I created one custom dialog which accepts the DSN information. Now I want to create the DSN using the given value. How to do that?

Your help would be appreciated.

[mikaelsorensen]

You can create the DSN by writing to the Windows Registry.

Below is a vbs example, that you can use for inspiration.

User DSN's are written into HKCU.
System DSN's are written into HKLM.


'--------------------- script begin
Dim DataSourceName
Dim DatabaseName
Dim Description
Dim DriverPath
Dim DriverName
Dim LastUser
Dim Server

Const SystemFolder= 1
Dim fso
Dim SysFolder
Dim SysFolderPath

DataSourceName = "DSNName" 'Change this
Description = "Data Source Description" 'Change this
Server = "ServerName" 'Change this
LastUser = "DBUser" 'Change this
DriverName = "SQL Server" 'Do NOT change the driver name if using SQL Server.

Set fso = wscript.CreateObject("Scripting.FileSystemObject")
Set SysFolder = fso.GetSpecialFolder(SystemFolder)
SysFolderPath = SysFolder.Path

DriverPath = SysFolderPath & "\sqlsrv32.dll"

Set WshShell = WScript.CreateObject("WScript.Shell")

Dim RegEdPath
RegEdPath= "HKLM\SOFTWARE\ODBC\ODBC.INI\" & DataSourceName & "\"

WshShell.RegWrite RegEdPath , ""

WshShell.RegWrite RegEdPath & "Description" , Description
WshShell.RegWrite RegEdPath & "Driver" , DriverPath
WshShell.RegWrite RegEdPath & "LastUser" , LastUser
WshShell.RegWrite RegEdPath & "Server" , Server

WshShell.RegWrite "HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\" & DataSourceName , DriverName

wscript.Quit


'----------------- script end

Best Regards
Mikael Sorensen

[MrSmersh]

Or if the aforementioned is not satisfactory you can use ODBC programming (the sample is from MSDN). Yes you need to "import it " to script but is simple and even you can find on the sample part of this site the code I think.

#include <stdio.h>
#include <windows.h>
#include "sql.h"
#include <odbcinst.h>

int main()
{
RETCODE retcode;

UCHAR *szDriver = "SQL Server";
UCHAR *szAttributes =
"DSN=MyDSN\0DESCRIPTION=SQLConfigDSN Sample\0"
"SERVER=MySQL\0ADDRESS=MyServer\0NETWORK=dbmssocn\0"
"DATABASE=pubs\0";

retcode = SQLConfigDataSource(NULL,
ODBC_ADD_DSN,
szDriver,
szAttributes);
}