Will this work?
store SQLSTRINGCONNECT(;
'Driver={SQL Server};'+;
'SERVER=MyServer;'+;
'QueryLog_On=Yes;'+;
'StatsLog_On=Yes;'+;
'Trusted_Connection=Yes');
TO gnConnHandle
>It is set up on that way the server as well. The connection in the DBC works properly if I create it on site. I simply can't re-create it programmatically.
>
>Here's what GenDBC created from the original DBC:
>CREATE CONNECTION CONNECT1 ;
> DATASOURCE "MyDataSource" ;
> USERID "" ;
> PASSWORD ""
>
>Also specified in that connection dialog was a database name which GENDBC didn't use
>
>I'd like to do something more along the lines of:
>CREATE CONNECTION CONNECT1 ;
> CONNSTRING "DRIVER=SQL Server;
> SERVER=MyServer;
> NETWORK=DBMSSOCN;
> DATABASE=MyDatabase;
> Trusted_Connection=Yes"
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only