I have an SQL database setup but i don't know how to connect to it to set up a table. I have a vague idea about connectionstrings and such. I have a server name, a database name, a user id and a password. I would like to set it up so i can just enter the SQL commands and create a table and enter data. But first I need to connect to the database. Igo towww.connectionStrings.com
if you can solve it that is ok if not !! get back to me and tell me what error message you got !
Showing posts with label idea. Show all posts
Showing posts with label idea. Show all posts
Wednesday, March 7, 2012
connecting to a database
Friday, February 10, 2012
Connect to SQL Server 2000 from command line interface
Hi,
I need to implement command line interface to SQL Server 2000 ...
I have no idea from where to begin... What programming environment? What language? From where and how to connect to db? I'll be glad to accept any ideas.
Thank youosql, isql ?|||sorry, i didn't understand your answer...|||Originally posted by yuliam
sorry, i didn't understand your answer...
BOL (books on line):
The isql utility allows you to enter Transact-SQL statements, system procedures, and script files; and uses DB-Library to communicate with Microsoft SQL Server 2000.
The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. This utility uses ODBC to communicate with the server.|||Thank you very mach!!!
Now i have a clue from were to start
I need to implement command line interface to SQL Server 2000 ...
I have no idea from where to begin... What programming environment? What language? From where and how to connect to db? I'll be glad to accept any ideas.
Thank youosql, isql ?|||sorry, i didn't understand your answer...|||Originally posted by yuliam
sorry, i didn't understand your answer...
BOL (books on line):
The isql utility allows you to enter Transact-SQL statements, system procedures, and script files; and uses DB-Library to communicate with Microsoft SQL Server 2000.
The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. This utility uses ODBC to communicate with the server.|||Thank you very mach!!!
Now i have a clue from were to start
Subscribe to:
Posts (Atom)