Lost with creating a db connection... help!?

E

ebrastow

Hi,

I've been using PowerBuilder for 12 years (programming part time) and
thought I might give VB a try. I'm using Visual Studio 2005,
specifically VB. My SQL Server is SQL Server 2000 Standard, running on
a W2K Server.

So, in VB, I create a new project, and then click Add New Data Source..

I choose Database as the data source type.

I choose New Connection...

The data source is "Microsoft SQL Server (SqlClient)"

I choose my SQL Server from the list of available servers, and then
choose SQL Server authentication.

I put in the user name and password for the database.

I choose the database from the drop down.

When I click Test, it succeeds.

Now, when I proceed, I get an error on the Choose Your Database Objects
screen:

--
An error occurred while retreiving information from the database.

Failed to retrieve data for this request.
An exception occurred while executing a Transact-SQL statement or
batch.
Line 8: Incorrect syntax near '1'.
--


Any ideas what I'm doing wrong? I'm just trying to create a connection
to the only db I'll be using in this app.

Thanks,

Evan
 
G

GhostInAK

Hello ebrastow,

Your first mistake is using the IDE datasource crap. I say crap because
it's the mildest word I can think of for that abortive hunk of junk.

I would (and do) create connections in code, like so:

Dim tConnection As SqlConnection = New SqlConnection(CONNECTION_STRING_HERE)
Dim tCommand As SqlCommand = New SqlCommand

With tCommand
.Connection = tConnection
.CommandType = Text
.CommandText = "SELECT fields FROM table"
End With

Enjoy,
-Boo
 
C

Cor Ligthert [MVP]

ebrastow,

Did you already try it with not using the SQLServer password but just the
integrated security checkbox.

Normally that wizard is in version 2005 great.

Cor
 
E

ebrastow

Hi Cor,

Yes, I just tried using integrated security, and I got the same result.
I would have actually been surprised if that had worked, because the
database is set for SQL Server security. Somehow, though, I don't think
security is the problem given the error message I'm getting.

I can't imagine what's going on with it but I'll keep trying...

Thanks,

Evan
 
E

ebrastow

Hi Ghost,

Hmm... I will have to look into this. It bugs me that the wizard
doesn't work... there's nothing weird about my setup that would cause
it to error our, and I'd like to be sure my app is on stable ground,
you know?

What you're describing is how I used to make connections in
PowerBuilder. I assume it's similar in VB. I used to create a
transaction object and populate the various properties with the data
needed to connect, then, anytime I would need to use the db, I'd do it
through that object. Is that kind of where you're coming from?

Thanks,

Evan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top