Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection for DBC created on the fly
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00798547
Message ID:
00798587
Views:
38
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
Map
View

Click here to load this message in the networking platform