Connect to SQL Server Personal edition through ODBC from PB7 script.
Posted on 2004-04-01
When Sql Server 2000 Enterprise Edition (NOt personal)
ls_latest_dsn = 'siddiqsons'
sqlca.dbms = "ODBC"
sqlca.dbparm = "Connectstring='DSN="
sqlca.dbparm = sqlca.dbparm + ls_latest_dsn+"',disablebind=1"
IF SQLCA.SqlCode <> 0 THEN
MessageBox ("Cannot Connect to Database", sqlca.sqlerrtext)
So Far So Good.
Now I want to do the same thing in
SQL Sever 2000 Personal Edition to be run in window 98 where window authentication
is not supported.
I create datasource name [siddiqsons] through odBC manually with sql authentication
with user name = sa and password = 'ali' and the connection is successful.
Bu when I run the program it says
Not associated with trusted sql connection etc.
Login failed for user null.
A window pops up asking user id and password when provided then it connects.
I want to eliminate this pop up error message.
How to do so