General information
Title:
SQLstringconnect vfp6.0
Hello group
This is an example from MSDN Audat is a training server with no password
lcDSNLess="DRIVER = {SQL Server};" ;
+ "SERVER=Audat;" ;
+ "UID=sa;" ;
+ "DATABASE=PUBS;"
lnConnHandle=sqlstringconnect(m.lcDSNLess)
When I run it all it does is open a open file dialog called select Data
Source and asks me to select a data source.
I would like it to just create the connection handle and let me run some
commands in the Pubs database
Also if I was connecting to a remote server with just an ip address instead of audat would i just use
lcDSNLess="DRIVER = {SQL Server};" ;
+ "SERVER=255.255.255.64 ;" ;
+ "UID=sa;" ;
+ "DATABASE=PUBS;"
lnConnHandle=sqlstringconnect(m.lcDSNLess)
instead??
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