>
>
>> b = SQLDB('mssql://username:password@localhost:portnumber/databaseNAME')
>>
>> Can someone give me a some examples or link to any information where I
>> can see how a simple program connects to a SQL SERVER DB and selects a few
>> records from a table and displays them...
>>
>> I have been researching to find examples, but I have not found anything
>> specific to my problem,
>>
>>
>>
>>
>
this is how I access a local server. The machine is server-win2003.
db = DAL('mssql://*user*:*pass*@server-win2003\hcnsql07/vcidat')
In this case, the SQL Server has an instance name of hcnsql07
and the database is vcidat
Probably that part of the connection string is the trickiest (the server
name and instance). I use Microsoft SQL Server Management Studio to connect
to the database to prove to myself that I know exactly the name of the
server. In case you didn't know, there are free "Express" editions of
Management Studio for download.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
