I had big problems with the connection to a mssql server.
My working connection string is this:
mssql://DRIVER={SQL Server};SERVER=HOST\DATABASE,PORT;UID=USER;PWD=PASSWORD
On Wednesday, April 24, 2013 11:16:58 PM UTC+2, Tim Richardson wrote:
>
>
>
>>
>>> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
